/************
Ten tac gia : Ly Thien kim
Ngay tao : 8/16/2011
Noi dung : Delete 1 LIST_CRIME
************/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE NAME = 'sp_DeleteLIST_CRIME')
BEGIN
	DROP PROC sp_DeleteLIST_CRIME
END
GO
CREATE PROC sp_DeleteLIST_CRIME
	@ID					int,
	@Result				int out
	AS
	BEGIN
		IF EXISTS (SELECT * FROM LIST_CRIME WHERE  @ID = ID)
		BEGIN
			DELETE FROM LIST_CRIME
			WHERE @ID = ID
			SET @RESULT = 1
		END
		ELSE 
		BEGIN
			SET @RESULT = 0
		END
	END
